﻿CREATE VIEW [acms].[Site_View]
AS
	SELECT 
		Id, 
		Name,
		RootUrl,
		CreatedDateTime as Created,
		CID
	FROM [acms].[Site]
	Where Deleted = 0
